create or replace trigger trg_tasks
  before insert on tasks
  for each row
begin
  SELECT seq_tasks.nextval into :new.id from dual;
end trg_tasks;
/
